Pandas Profiling Report

Dataset statistics

Number of variables	10
Number of observations	2824
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	245.4 KiB
Average record size in memory	89.0 B

Variable types

Numeric	10

Alerts

`frequency_days` is highly overall correlated with `monetary_per_day`	High correlation
`gross_revenue` is highly overall correlated with `lifetime_days` and 3 other fields	High correlation
`lifetime_days` is highly overall correlated with `gross_revenue` and 1 other fields	High correlation
`monetary_per_day` is highly overall correlated with `frequency_days` and 2 other fields	High correlation
`orders_count` is highly overall correlated with `gross_revenue` and 2 other fields	High correlation
`qtd_produtos` is highly overall correlated with `gross_revenue` and 2 other fields	High correlation
`returns` is highly overall correlated with `returns_rate`	High correlation
`returns_rate` is highly overall correlated with `returns`	High correlation
`returns` is highly skewed (γ1 = 21.82144361)	Skewed
`monetary_per_day` is highly skewed (γ1 = 45.64509447)	Skewed
`customer_id` has unique values	Unique
`recency` has 33 (1.2%) zeros	Zeros
`frequency_days` has 51 (1.8%) zeros	Zeros
`returns` has 1524 (54.0%) zeros	Zeros
`returns_rate` has 1524 (54.0%) zeros	Zeros

Reproduction

Analysis started	2025-12-25 04:34:10.521122
Analysis finished	2025-12-25 04:34:23.350508
Duration	12.83 seconds
Software version	ydata-profiling vv4.18.0
Download configuration	config.json

customer_id
Real number (ℝ)

Unique

Distinct	2824
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15299.481

Minimum	12347
Maximum	18287
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	46.9 KiB

Quantile statistics

Minimum	12347
5-th percentile	12626.15
Q1	13826.25
median	15270.5
Q3	16801.75
95-th percentile	17953.55
Maximum	18287
Range	5940
Interquartile range (IQR)	2975.5

Descriptive statistics

Standard deviation	1714.421
Coefficient of variation (CV)	0.11205747
Kurtosis	-1.2049882
Mean	15299.481
Median Absolute Deviation (MAD)	1484
Skewness	0.0027127875
Sum	43205733
Variance	2939239.5
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
17850	1	< 0.1%
13047	1	< 0.1%
12583	1	< 0.1%
13748	1	< 0.1%
15100	1	< 0.1%
15291	1	< 0.1%
14688	1	< 0.1%
17809	1	< 0.1%
15311	1	< 0.1%
16098	1	< 0.1%
Other values (2814)	2814	99.6%

Value	Count	Frequency (%)
12347	1	< 0.1%
12348	1	< 0.1%
12352	1	< 0.1%
12356	1	< 0.1%
12358	1	< 0.1%
12359	1	< 0.1%
12360	1	< 0.1%
12362	1	< 0.1%
12364	1	< 0.1%
12370	1	< 0.1%

Value	Count	Frequency (%)
18287	1	< 0.1%
18283	1	< 0.1%
18282	1	< 0.1%
18273	1	< 0.1%
18272	1	< 0.1%
18270	1	< 0.1%
18265	1	< 0.1%
18263	1	< 0.1%
18261	1	< 0.1%
18260	1	< 0.1%

gross_revenue
Real number (ℝ)

High correlation

Distinct	2811
Distinct (%)	99.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2820.8528

Minimum	36.56
Maximum	279138.02
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	44.1 KiB

Quantile statistics

Minimum	36.56
5-th percentile	251.876
Q1	614.015
median	1142.935
Q3	2388.8375
95-th percentile	7433.5075
Maximum	279138.02
Range	279101.46
Interquartile range (IQR)	1774.8225

Descriptive statistics

Standard deviation	10401.624
Coefficient of variation (CV)	3.687404
Kurtosis	375.53948
Mean	2820.8528
Median Absolute Deviation (MAD)	683.02
Skewness	17.129036
Sum	7966088.4
Variance	1.0819378 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2053.02	2	0.1%
1078.96	2	0.1%
379.65	2	0.1%
901.2	2	0.1%
598.2	2	0.1%
178.96	2	0.1%
331	2	0.1%
1353.74	2	0.1%
745.06	2	0.1%
650.43	2	0.1%
Other values (2801)	2804	99.3%

Value	Count	Frequency (%)
36.56	1	< 0.1%
52	1	< 0.1%
52.2	1	< 0.1%
62.43	1	< 0.1%
68.84	1	< 0.1%
70.02	1	< 0.1%
77.4	1	< 0.1%
84.65	1	< 0.1%
90.3	1	< 0.1%
93.35	1	< 0.1%

Value	Count	Frequency (%)
279138.02	1	< 0.1%
259657.3	1	< 0.1%
194550.79	1	< 0.1%
140450.72	1	< 0.1%
124564.53	1	< 0.1%
117379.63	1	< 0.1%
91062.38	1	< 0.1%
72882.09	1	< 0.1%
66653.56	1	< 0.1%
65039.62	1	< 0.1%

recency
Real number (ℝ)

Zeros

Distinct	257
Distinct (%)	9.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	58.105524

Minimum	0
Maximum	373
Zeros	33
Zeros (%)	1.2%
Negative	0
Negative (%)	0.0%
Memory size	44.1 KiB

Quantile statistics

Minimum	0
5-th percentile	2
Q1	10
median	29
Q3	74
95-th percentile	215
Maximum	373
Range	373
Interquartile range (IQR)	64

Descriptive statistics

Standard deviation	70.215004
Coefficient of variation (CV)	1.208405
Kurtosis	3.2614675
Mean	58.105524
Median Absolute Deviation (MAD)	24
Skewness	1.8722169
Sum	164090
Variance	4930.1468
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	99	3.5%
4	87	3.1%
2	86	3.0%
3	85	3.0%
8	76	2.7%
10	69	2.4%
9	66	2.3%
7	65	2.3%
17	62	2.2%
22	56	2.0%
Other values (247)	2073	73.4%

Value	Count	Frequency (%)
0	33	1.2%
1	99	3.5%
2	86	3.0%
3	85	3.0%
4	87	3.1%
5	43	1.5%
7	65	2.3%
8	76	2.7%
9	66	2.3%
10	69	2.4%

Value	Count	Frequency (%)
373	1	< 0.1%
372	1	< 0.1%
369	1	< 0.1%
366	1	< 0.1%
360	1	< 0.1%
358	3	0.1%
354	1	< 0.1%
337	1	< 0.1%
336	2	0.1%
334	1	< 0.1%

qtd_produtos
Real number (ℝ)

High correlation

Distinct	1653
Distinct (%)	58.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1648.7755

Minimum	2
Maximum	196844
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	44.1 KiB

Quantile statistics

Minimum	2
5-th percentile	114.15
Q1	323
median	683.5
Q3	1468.25
95-th percentile	4538.4
Maximum	196844
Range	196842
Interquartile range (IQR)	1145.25

Descriptive statistics

Standard deviation	5840.5383
Coefficient of variation (CV)	3.5423491
Kurtosis	493.5989
Mean	1648.7755
Median Absolute Deviation (MAD)	441.5
Skewness	18.32383
Sum	4656142
Variance	34111888
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
310	11	0.4%
246	8	0.3%
150	8	0.3%
516	7	0.2%
219	7	0.2%
200	7	0.2%
260	7	0.2%
272	7	0.2%
394	7	0.2%
1200	7	0.2%
Other values (1643)	2748	97.3%

Value	Count	Frequency (%)
2	1	< 0.1%
16	1	< 0.1%
17	1	< 0.1%
19	1	< 0.1%
20	1	< 0.1%
24	1	< 0.1%
25	1	< 0.1%
27	2	0.1%
30	1	< 0.1%
32	1	< 0.1%

Value	Count	Frequency (%)
196844	1	< 0.1%
80263	1	< 0.1%
77373	1	< 0.1%
69993	1	< 0.1%
64549	1	< 0.1%
64124	1	< 0.1%
63312	1	< 0.1%
58343	1	< 0.1%
57885	1	< 0.1%
50255	1	< 0.1%

orders_count
Real number (ℝ)

High correlation

Distinct	55
Distinct (%)	1.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.983711

Minimum	2
Maximum	206
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	44.1 KiB

Quantile statistics

Minimum	2
5-th percentile	2
Q1	2
median	4
Q3	6
95-th percentile	17
Maximum	206
Range	204
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	9.0058675
Coefficient of variation (CV)	1.5050639
Kurtosis	186.37707
Mean	5.983711
Median Absolute Deviation (MAD)	2
Skewness	10.688153
Sum	16898
Variance	81.10565
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2	825	29.2%
3	503	17.8%
4	394	14.0%
5	237	8.4%
6	173	6.1%
7	138	4.9%
8	98	3.5%
9	69	2.4%
10	55	1.9%
11	54	1.9%
Other values (45)	278	9.8%

Value	Count	Frequency (%)
2	825	29.2%
3	503	17.8%
4	394	14.0%
5	237	8.4%
6	173	6.1%
7	138	4.9%
8	98	3.5%
9	69	2.4%
10	55	1.9%
11	54	1.9%

Value	Count	Frequency (%)
206	1	< 0.1%
199	1	< 0.1%
124	1	< 0.1%
97	1	< 0.1%
91	2	0.1%
86	1	< 0.1%
72	1	< 0.1%
62	2	0.1%
60	1	< 0.1%
57	1	< 0.1%

frequency_days
Real number (ℝ)

High correlation Zeros

Distinct	1218
Distinct (%)	43.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	73.078754

Minimum	0
Maximum	366
Zeros	51
Zeros (%)	1.8%
Negative	0
Negative (%)	0.0%
Memory size	44.1 KiB

Quantile statistics

Minimum	0
5-th percentile	9.55
Q1	30
median	54
Q3	92.666667
95-th percentile	212.7
Maximum	366
Range	366
Interquartile range (IQR)	62.666667

Descriptive statistics

Standard deviation	65.524224
Coefficient of variation (CV)	0.89662482
Kurtosis	4.1469104
Mean	73.078754
Median Absolute Deviation (MAD)	28.703297
Skewness	1.9133911
Sum	206374.4
Variance	4293.424
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	51	1.8%
31	20	0.7%
70	20	0.7%
14	16	0.6%
21	16	0.6%
46	15	0.5%
42	15	0.5%
55	15	0.5%
49	14	0.5%
26	13	0.5%
Other values (1208)	2629	93.1%

Value	Count	Frequency (%)
0	51	1.8%
0.0303030303	1	< 0.1%
0.2	1	< 0.1%
0.3333333333	1	< 0.1%
0.8571428571	1	< 0.1%
1	8	0.3%
1.5	1	< 0.1%
1.819512195	1	< 0.1%
1.878787879	1	< 0.1%
2	3	0.1%

Value	Count	Frequency (%)
366	1	< 0.1%
365	1	< 0.1%
364	1	< 0.1%
363	1	< 0.1%
357	2	0.1%
356	1	< 0.1%
355	2	0.1%
352	1	< 0.1%
351	2	0.1%
350	3	0.1%

returns
Real number (ℝ)

High correlation Skewed Zeros

Distinct	204
Distinct (%)	7.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	34.408994

Minimum	0
Maximum	9014
Zeros	1524
Zeros (%)	54.0%
Negative	0
Negative (%)	0.0%
Memory size	44.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	8
95-th percentile	93.7
Maximum	9014
Range	9014
Interquartile range (IQR)	8

Descriptive statistics

Standard deviation	288.11229
Coefficient of variation (CV)	8.373168
Kurtosis	582.17626
Mean	34.408994
Median Absolute Deviation (MAD)	0
Skewness	21.821444
Sum	97171
Variance	83008.692
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1524	54.0%
1	131	4.6%
2	118	4.2%
3	82	2.9%
4	72	2.5%
6	63	2.2%
5	56	2.0%
12	46	1.6%
8	39	1.4%
9	38	1.3%
Other values (194)	655	23.2%

Value	Count	Frequency (%)
0	1524	54.0%
1	131	4.6%
2	118	4.2%
3	82	2.9%
4	72	2.5%
5	56	2.0%
6	63	2.2%
7	38	1.3%
8	39	1.4%
9	38	1.3%

Value	Count	Frequency (%)
9014	1	< 0.1%
8004	1	< 0.1%
4427	1	< 0.1%
3768	1	< 0.1%
3332	1	< 0.1%
2878	1	< 0.1%
2022	1	< 0.1%
2012	1	< 0.1%
1776	1	< 0.1%
1594	1	< 0.1%

returns_rate
Real number (ℝ)

High correlation Zeros

Distinct	1243
Distinct (%)	44.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.017013814

Minimum	0
Maximum	1.5519126
Zeros	1524
Zeros (%)	54.0%
Negative	0
Negative (%)	0.0%
Memory size	44.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0.0082890855
95-th percentile	0.071953056
Maximum	1.5519126
Range	1.5519126
Interquartile range (IQR)	0.0082890855

Descriptive statistics

Standard deviation	0.068751358
Coefficient of variation (CV)	4.040914
Kurtosis	139.1544
Mean	0.017013814
Median Absolute Deviation (MAD)	0
Skewness	9.6918246
Sum	48.047011
Variance	0.0047267493
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1524	54.0%
0.009661835749	4	0.1%
0.5	3	0.1%
0.007462686567	3	0.1%
0.0243902439	3	0.1%
0.01360544218	3	0.1%
0.01492537313	3	0.1%
0.002463054187	3	0.1%
0.01229508197	3	0.1%
0.002309468822	3	0.1%
Other values (1233)	1272	45.0%

Value	Count	Frequency (%)
0	1524	54.0%
0.0001169636243	1	< 0.1%
0.0001839926403	1	< 0.1%
0.0002816901408	1	< 0.1%
0.0003140703518	1	< 0.1%
0.0003619254434	1	< 0.1%
0.0003632401017	1	< 0.1%
0.0003637686431	1	< 0.1%
0.0003671071953	1	< 0.1%
0.000393081761	1	< 0.1%

Value	Count	Frequency (%)
1.551912568	1	< 0.1%
1	1	< 0.1%
0.9863013699	1	< 0.1%
0.6333333333	1	< 0.1%
0.6008836524	1	< 0.1%
0.5964566929	1	< 0.1%
0.5648854962	1	< 0.1%
0.5646387833	1	< 0.1%
0.5602040816	1	< 0.1%
0.5399061033	1	< 0.1%

lifetime_days
Real number (ℝ)

High correlation

Distinct	374
Distinct (%)	13.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	201.35517

Minimum	1
Maximum	374
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	44.1 KiB

Quantile statistics

Minimum	1
5-th percentile	18
Q1	102
median	210
Q3	302
95-th percentile	363
Maximum	374
Range	373
Interquartile range (IQR)	200

Descriptive statistics

Standard deviation	113.49623
Coefficient of variation (CV)	0.56366187
Kurtosis	-1.225398
Mean	201.35517
Median Absolute Deviation (MAD)	99
Skewness	-0.15790104
Sum	568627
Variance	12881.395
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	51	1.8%
365	28	1.0%
351	26	0.9%
358	25	0.9%
367	20	0.7%
352	20	0.7%
356	19	0.7%
344	18	0.6%
366	18	0.6%
189	17	0.6%
Other values (364)	2582	91.4%

Value	Count	Frequency (%)
1	51	1.8%
2	9	0.3%
3	4	0.1%
4	5	0.2%
5	4	0.1%
6	3	0.1%
7	2	0.1%
8	7	0.2%
9	5	0.2%
10	3	0.1%

Value	Count	Frequency (%)
374	5	0.2%
373	8	0.3%
372	8	0.3%
371	8	0.3%
370	6	0.2%
369	10	0.4%
368	11	0.4%
367	20	0.7%
366	18	0.6%
365	28	1.0%

monetary_per_day
Real number (ℝ)

High correlation Skewed

Distinct	2822
Distinct (%)	99.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	45.616004

Minimum	0.11078788
Maximum	39916.5
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	44.1 KiB

Quantile statistics

Minimum	0.11078788
5-th percentile	1.6363994
Q1	4.0651576
median	7.896662
Q3	15.630297
95-th percentile	67.006128
Maximum	39916.5
Range	39916.389
Interquartile range (IQR)	11.565139

Descriptive statistics

Standard deviation	797.8526
Coefficient of variation (CV)	17.490629
Kurtosis	2231.5863
Mean	45.616004
Median Absolute Deviation (MAD)	4.6874122
Skewness	45.645094
Sum	128819.6
Variance	636568.77
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3.756363636	2	0.1%
26.4	2	0.1%
18.02521505	1	< 0.1%
3.39874552	1	< 0.1%
21.36585366	1	< 0.1%
13.24727794	1	< 0.1%
90.12714286	1	< 0.1%
43.27923754	1	< 0.1%
2695.605	1	< 0.1%
80.13043478	1	< 0.1%
Other values (2812)	2812	99.6%

Value	Count	Frequency (%)
0.1107878788	1	< 0.1%
0.1426229508	1	< 0.1%
0.3350239234	1	< 0.1%
0.3712719298	1	< 0.1%
0.4097619048	1	< 0.1%
0.4855769231	1	< 0.1%
0.5902439024	1	< 0.1%
0.6115384615	1	< 0.1%
0.6245747801	1	< 0.1%
0.6364556962	1	< 0.1%

Value	Count	Frequency (%)
39916.5	1	< 0.1%
12393.7	1	< 0.1%
4219.17	1	< 0.1%
2949.75	1	< 0.1%
2695.605	1	< 0.1%
1760.96	1	< 0.1%
1345.62	1	< 0.1%
1309.14	1	< 0.1%
1145.6	1	< 0.1%
977.77	1	< 0.1%

	customer_id	frequency_days	gross_revenue	lifetime_days	monetary_per_day	orders_count	qtd_produtos	recency	returns	returns_rate
customer_id	1.000	-0.032	-0.094	-0.009	-0.070	0.004	-0.085	0.014	-0.062	-0.052
frequency_days	-0.032	1.000	-0.343	0.231	-0.763	-0.453	-0.318	0.188	-0.216	-0.147
gross_revenue	-0.094	-0.343	1.000	0.523	0.561	0.764	0.920	-0.379	0.463	0.332
lifetime_days	-0.009	0.231	0.523	1.000	-0.270	0.653	0.485	-0.435	0.305	0.226
monetary_per_day	-0.070	-0.763	0.561	-0.270	1.000	0.244	0.522	-0.114	0.252	0.160
orders_count	0.004	-0.453	0.764	0.653	0.244	1.000	0.705	-0.453	0.431	0.323
qtd_produtos	-0.085	-0.318	0.920	0.485	0.522	0.705	1.000	-0.372	0.425	0.281
recency	0.014	0.188	-0.379	-0.435	-0.114	-0.453	-0.372	1.000	-0.189	-0.122
returns	-0.062	-0.216	0.463	0.305	0.252	0.431	0.425	-0.189	1.000	0.970
returns_rate	-0.052	-0.147	0.332	0.226	0.160	0.323	0.281	-0.122	0.970	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

	customer_id	gross_revenue	recency	qtd_produtos	orders_count	frequency_days	returns	returns_rate	lifetime_days	monetary_per_day
0	17850	5391.21	372.0	1733.0	34.0	0.030303	40.0	0.023081	2.0	2695.605000
1	13047	3232.59	56.0	1390.0	9.0	39.625000	35.0	0.025180	318.0	10.165377
2	12583	6705.38	2.0	5028.0	15.0	26.500000	50.0	0.009944	372.0	18.025215
3	13748	948.25	95.0	439.0	5.0	69.500000	0.0	0.000000	279.0	3.398746
4	15100	876.00	333.0	80.0	3.0	20.000000	22.0	0.275000	41.0	21.365854
5	15291	4623.30	25.0	2102.0	14.0	26.769231	29.0	0.013796	349.0	13.247278
6	14688	5630.87	7.0	3621.0	21.0	18.300000	399.0	0.110191	367.0	15.342970
7	17809	5411.91	16.0	2057.0	12.0	32.454545	41.0	0.019932	358.0	15.117067
8	15311	60767.90	0.0	38194.0	91.0	4.144444	474.0	0.012410	374.0	162.481016
9	16098	2005.63	87.0	613.0	7.0	47.666667	0.0	0.000000	287.0	6.988258

	customer_id	gross_revenue	recency	qtd_produtos	orders_count	frequency_days	returns	returns_rate	lifetime_days	monetary_per_day
5637	17468	137.00	10.0	116.0	2.0	4.000000	0.0	0.000000	5.0	27.400000
5648	13596	697.04	5.0	406.0	2.0	7.000000	0.0	0.000000	8.0	87.130000
5654	14893	1237.85	9.0	799.0	2.0	2.000000	0.0	0.000000	3.0	412.616667
5656	17852	114.34	11.0	53.0	2.0	0.000000	0.0	0.000000	1.0	114.340000
5673	17772	182.77	10.0	58.0	2.0	0.000000	0.0	0.000000	1.0	182.770000
5679	14126	706.13	7.0	508.0	3.0	1.500000	50.0	0.098425	4.0	176.532500
5680	16479	300.83	10.0	102.0	2.0	0.000000	0.0	0.000000	1.0	300.830000
5685	13521	1092.39	1.0	733.0	3.0	4.500000	0.0	0.000000	10.0	109.239000
5695	15060	301.84	8.0	262.0	4.0	0.333333	0.0	0.000000	2.0	150.920000
5765	16000	12393.70	2.0	5110.0	3.0	0.000000	0.0	0.000000	1.0	12393.700000

Overview

Interactions

Correlations

Missing values

Sample

Overview

Variables

Interactions

Correlations

Missing values

Sample